# coding:utf-8

import pymysql

db = pymysql.connect("localhost","root","boyun2017","py_mysql")
cursor = db.cursor()
cursor.execute("DROP TABLE IF EXISTS employee")
sql = """CREATE TABLE employee(
        first_name VARCHAR (20) NOT NULL,
        last_name VARCHAR(20),
        age INT,
        sex CHAR(1),
        income FLOAT )"""
cursor.execute(sql)
db.close()

